<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en"><title id="hi141670">pg_resqueue</title>
  <body>
    <note>The <codeph>pg_resqueue</codeph> system catalog table is valid only when resource queue-based resource management is active.</note>
    <p>The <codeph>pg_resqueue</codeph> system catalog table contains information about Greenplum Database resource queues, which are used for the resource management feature.
      This table is populated only on the master. This table is defined in the
        <codeph>pg_global</codeph> tablespace, meaning it is globally shared across all databases in
      the system.</p>
    <table id="hi141982"><title>pg_catalog.pg_resqueue</title><tgroup cols="4"><colspec colnum="1" colname="col1" colwidth="131pt"/><colspec colnum="2" colname="col2" colwidth="86pt"/><colspec colnum="3" colname="col3" colwidth="85pt"/><colspec colnum="4" colname="col4" colwidth="147pt"/><thead><row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row></thead><tbody><row><entry colname="col1"><codeph>rsqname</codeph></entry><entry colname="col2">name</entry><entry colname="col3"/><entry colname="col4">The name of the resource queue.</entry></row><row><entry colname="col1"><codeph>rsqcountlimit</codeph></entry><entry colname="col2">real</entry><entry colname="col3"/><entry colname="col4">The active query threshold of the resource queue.</entry></row><row><entry colname="col1"><codeph>rsqcostlimit</codeph></entry><entry colname="col2">real</entry><entry colname="col3"/><entry colname="col4">The query cost threshold of the resource queue.</entry></row><row><entry colname="col1"><codeph>rsqovercommit</codeph></entry><entry colname="col2">boolean</entry><entry colname="col3"/><entry colname="col4">Allows queries that exceed the cost threshold
to run when the system is idle.</entry></row><row><entry colname="col1"><codeph>rsqignorecostlimit</codeph></entry><entry colname="col2">real</entry><entry colname="col3"/><entry colname="col4">The query cost limit of what is considered a
'small query'. Queries with a cost under this limit will not be queued
and run immediately.</entry></row></tbody></tgroup></table></body></topic>
